<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.20"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>libxlsxwriter: chart_area.c</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="customdoxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">libxlsxwriter
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.20 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
</div><!-- top -->
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">chart_area.c</div>  </div>
</div><!--header-->
<div class="contents">
<table width="600">
<tr>
<td><a class="el" href="chart_8c-example.html">&lt;&lt; chart.c</a> </td><td align="right"><a class="el" href="chart_bar_8c-example.html">chart_bar.c &gt;&gt;</a>  </td></tr>
</table>
<p>Example of creating Excel Area charts. Three types of area chart are shown.</p>
<p>The default area chart: </p><div class="image">
<img src="chart_area1.png" alt=""/>
</div>
<p>Stacked area chart: </p><div class="image">
<img src="chart_area2.png" alt=""/>
</div>
<p>Percent stacked area chart: </p><div class="image">
<img src="chart_area3.png" alt=""/>
</div>
<div class="fragment"><div class="line"><span class="comment">/*</span></div>
<div class="line"><span class="comment"> * An example of creating Excel area charts using the libxlsxwriter library.</span></div>
<div class="line"><span class="comment"> *</span></div>
<div class="line"><span class="comment"> * Copyright 2014-2018, John McNamara, jmcnamara@cpan.org</span></div>
<div class="line"><span class="comment"> *</span></div>
<div class="line"><span class="comment"> */</span></div>
<div class="line"> </div>
<div class="line"><span class="preprocessor">#include &quot;xlsxwriter.h&quot;</span></div>
<div class="line"> </div>
<div class="line"><span class="comment">/*</span></div>
<div class="line"><span class="comment"> * Write some data to the worksheet.</span></div>
<div class="line"><span class="comment"> */</span></div>
<div class="line"><span class="keywordtype">void</span> write_worksheet_data(<a name="_a0"></a><a class="code" href="structlxw__worksheet.html">lxw_worksheet</a> *worksheet, <a name="_a1"></a><a class="code" href="structlxw__format.html">lxw_format</a> *bold) {</div>
<div class="line"> </div>
<div class="line">    <span class="keywordtype">int</span> row, col;</div>
<div class="line">    uint8_t data[6][3] = {</div>
<div class="line">        <span class="comment">/* Three columns of data. */</span></div>
<div class="line">        {2, 40, 30},</div>
<div class="line">        {3, 40, 25},</div>
<div class="line">        {4, 50, 30},</div>
<div class="line">        {5, 30, 10},</div>
<div class="line">        {6, 25,  5},</div>
<div class="line">        {7, 50, 10}</div>
<div class="line">    };</div>
<div class="line"> </div>
<div class="line">    <a name="a2"></a><a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet, <a name="a3"></a><a class="code" href="utility_8h.html#ad510ac6df573d23203374e24dba373d2">CELL</a>(<span class="stringliteral">&quot;A1&quot;</span>), <span class="stringliteral">&quot;Number&quot;</span>,  bold);</div>
<div class="line">    <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet, <a class="code" href="utility_8h.html#ad510ac6df573d23203374e24dba373d2">CELL</a>(<span class="stringliteral">&quot;B1&quot;</span>), <span class="stringliteral">&quot;Batch 1&quot;</span>, bold);</div>
<div class="line">    <a class="code" href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a>(worksheet, <a class="code" href="utility_8h.html#ad510ac6df573d23203374e24dba373d2">CELL</a>(<span class="stringliteral">&quot;C1&quot;</span>), <span class="stringliteral">&quot;Batch 2&quot;</span>, bold);</div>
<div class="line"> </div>
<div class="line">    <span class="keywordflow">for</span> (row = 0; row &lt; 6; row++)</div>
<div class="line">        <span class="keywordflow">for</span> (col = 0; col &lt; 3; col++)</div>
<div class="line">            <a name="a4"></a><a class="code" href="worksheet_8h.html#ad9fc47d3beaa2ab4759414e8580c2289">worksheet_write_number</a>(worksheet, row + 1, col, data[row][col] , NULL);</div>
<div class="line">}</div>
<div class="line"> </div>
<div class="line"><span class="comment">/*</span></div>
<div class="line"><span class="comment"> * Create a worksheet with examples charts.</span></div>
<div class="line"><span class="comment"> */</span></div>
<div class="line"><span class="keywordtype">int</span> main() {</div>
<div class="line"> </div>
<div class="line">    <a name="_a5"></a><a class="code" href="structlxw__workbook.html">lxw_workbook</a>     *workbook  = <a name="a6"></a><a class="code" href="workbook_8h.html#a1cf96608a23ee4eb0e8467c15240d00b">workbook_new</a>(<span class="stringliteral">&quot;chart_area.xlsx&quot;</span>);</div>
<div class="line">    <a class="code" href="structlxw__worksheet.html">lxw_worksheet</a>    *worksheet = <a name="a7"></a><a class="code" href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a>(workbook, NULL);</div>
<div class="line">    <a name="_a8"></a><a class="code" href="structlxw__chart__series.html">lxw_chart_series</a> *series;</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add a bold format to use to highlight the header cells. */</span></div>
<div class="line">    <a class="code" href="structlxw__format.html">lxw_format</a> *bold = <a name="a9"></a><a class="code" href="workbook_8h.html#a279a5d7075d09a3931aae9782afede33">workbook_add_format</a>(workbook);</div>
<div class="line">    <a name="a10"></a><a class="code" href="format_8h.html#a85e1b0baf44b445b65894e48722aec14">format_set_bold</a>(bold);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Write some data for the chart. */</span></div>
<div class="line">    write_worksheet_data(worksheet, bold);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/*</span></div>
<div class="line"><span class="comment">     * Chart 1. Create a area chart.</span></div>
<div class="line"><span class="comment">     */</span></div>
<div class="line">    <a name="_a11"></a><a class="code" href="structlxw__chart.html">lxw_chart</a> *chart = <a name="a12"></a><a class="code" href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726">workbook_add_chart</a>(workbook, <a name="a13"></a><a class="code" href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85cab7d204b0c88aa41565b792a3ac946e73">LXW_CHART_AREA</a>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add the first series to the chart. */</span></div>
<div class="line">    series = <a name="a14"></a><a class="code" href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a>(chart, <span class="stringliteral">&quot;=Sheet1!$A$2:$A$7&quot;</span>, <span class="stringliteral">&quot;=Sheet1!$B$2:$B$7&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set the name for the series instead of the default &quot;Series 1&quot;. */</span></div>
<div class="line">    <a name="a15"></a><a class="code" href="chart_8h.html#a4361fb66cf0e15501995f89466888578">chart_series_set_name</a>(series, <span class="stringliteral">&quot;=Sheet1!$B$1&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add a second series but leave the categories and values undefined. They</span></div>
<div class="line"><span class="comment">     * can be defined later using the alternative syntax shown below.  */</span></div>
<div class="line">    series = <a class="code" href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a>(chart, NULL, NULL);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Configure the series using a syntax that is easier to define programmatically. */</span></div>
<div class="line">    <a name="a16"></a><a class="code" href="chart_8h.html#abfde30539e8538e64eee370797b4abc5">chart_series_set_categories</a>(series, <span class="stringliteral">&quot;Sheet1&quot;</span>, 1, 0, 6, 0); <span class="comment">/* &quot;=Sheet1!$A$2:$A$7&quot; */</span></div>
<div class="line">    <a name="a17"></a><a class="code" href="chart_8h.html#ac29dbe36b53288990ec0b20dddbaf967">chart_series_set_values</a>(series,     <span class="stringliteral">&quot;Sheet1&quot;</span>, 1, 2, 6, 2); <span class="comment">/* &quot;=Sheet1!$C$2:$C$7&quot; */</span></div>
<div class="line">    <a name="a18"></a><a class="code" href="chart_8h.html#afcd0c12a60048ef0240aba415f528e39">chart_series_set_name_range</a>(series, <span class="stringliteral">&quot;Sheet1&quot;</span>, 0, 2);       <span class="comment">/* &quot;=Sheet1!$C$1&quot;      */</span></div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add a chart title and some axis labels. */</span></div>
<div class="line">    <a name="a19"></a><a class="code" href="chart_8h.html#aa0a0b3eadc51a608c76bb9473943e191">chart_title_set_name</a>(chart,        <span class="stringliteral">&quot;Results of sample analysis&quot;</span>);</div>
<div class="line">    <a name="a20"></a><a class="code" href="chart_8h.html#a650d569ff37a087101b7bff4ee7bb130">chart_axis_set_name</a>(chart-&gt;<a name="a21"></a><a class="code" href="structlxw__chart.html#a17fa7931e6825a60de50444438e7f718">x_axis</a>, <span class="stringliteral">&quot;Test number&quot;</span>);</div>
<div class="line">    <a class="code" href="chart_8h.html#a650d569ff37a087101b7bff4ee7bb130">chart_axis_set_name</a>(chart-&gt;<a name="a22"></a><a class="code" href="structlxw__chart.html#aec951bda729ea8184fa0827c5f091f37">y_axis</a>, <span class="stringliteral">&quot;Sample length (mm)&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set an Excel chart style. */</span></div>
<div class="line">    <a name="a23"></a><a class="code" href="chart_8h.html#a6865755f0adb52e41466a6576a8a030e">chart_set_style</a>(chart, 11);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Insert the chart into the worksheet. */</span></div>
<div class="line">    <a name="a24"></a><a class="code" href="worksheet_8h.html#ac2067faaacb8bfa6550b019e915900a2">worksheet_insert_chart</a>(worksheet, <a class="code" href="utility_8h.html#ad510ac6df573d23203374e24dba373d2">CELL</a>(<span class="stringliteral">&quot;E2&quot;</span>), chart);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/*</span></div>
<div class="line"><span class="comment">     * Chart 2. Create a stacked area chart.</span></div>
<div class="line"><span class="comment">     */</span></div>
<div class="line">    chart = <a class="code" href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726">workbook_add_chart</a>(workbook, <a name="a25"></a><a class="code" href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85caf78202456c43feb53a91c2f56fd3341b">LXW_CHART_AREA_STACKED</a>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add the first series to the chart. */</span></div>
<div class="line">    series = <a class="code" href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a>(chart, <span class="stringliteral">&quot;=Sheet1!$A$2:$A$7&quot;</span>, <span class="stringliteral">&quot;=Sheet1!$B$2:$B$7&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set the name for the series instead of the default &quot;Series 1&quot;. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#a4361fb66cf0e15501995f89466888578">chart_series_set_name</a>(series, <span class="stringliteral">&quot;=Sheet1!$B$1&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add the second series to the chart. */</span></div>
<div class="line">    series = <a class="code" href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a>(chart, <span class="stringliteral">&quot;=Sheet1!$A$2:$A$7&quot;</span>, <span class="stringliteral">&quot;=Sheet1!$C$2:$C$7&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set the name for the series instead of the default &quot;Series 2&quot;. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#a4361fb66cf0e15501995f89466888578">chart_series_set_name</a>(series, <span class="stringliteral">&quot;=Sheet1!$C$1&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add a chart title and some axis labels. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#aa0a0b3eadc51a608c76bb9473943e191">chart_title_set_name</a>(chart,        <span class="stringliteral">&quot;Results of sample analysis&quot;</span>);</div>
<div class="line">    <a class="code" href="chart_8h.html#a650d569ff37a087101b7bff4ee7bb130">chart_axis_set_name</a>(chart-&gt;<a class="code" href="structlxw__chart.html#a17fa7931e6825a60de50444438e7f718">x_axis</a>, <span class="stringliteral">&quot;Test number&quot;</span>);</div>
<div class="line">    <a class="code" href="chart_8h.html#a650d569ff37a087101b7bff4ee7bb130">chart_axis_set_name</a>(chart-&gt;<a class="code" href="structlxw__chart.html#aec951bda729ea8184fa0827c5f091f37">y_axis</a>, <span class="stringliteral">&quot;Sample length (mm)&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set an Excel chart style. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#a6865755f0adb52e41466a6576a8a030e">chart_set_style</a>(chart, 12);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Insert the chart into the worksheet. */</span></div>
<div class="line">    <a class="code" href="worksheet_8h.html#ac2067faaacb8bfa6550b019e915900a2">worksheet_insert_chart</a>(worksheet, <a class="code" href="utility_8h.html#ad510ac6df573d23203374e24dba373d2">CELL</a>(<span class="stringliteral">&quot;E18&quot;</span>), chart);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="comment">/*</span></div>
<div class="line"><span class="comment">     * Chart 3. Create a percent stacked area chart.</span></div>
<div class="line"><span class="comment">     */</span></div>
<div class="line">    chart = <a class="code" href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726">workbook_add_chart</a>(workbook, <a name="a26"></a><a class="code" href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85ca9df7f4ab4ee2fc2e45937e3937046d17">LXW_CHART_AREA_STACKED_PERCENT</a>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add the first series to the chart. */</span></div>
<div class="line">    series = <a class="code" href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a>(chart, <span class="stringliteral">&quot;=Sheet1!$A$2:$A$7&quot;</span>, <span class="stringliteral">&quot;=Sheet1!$B$2:$B$7&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set the name for the series instead of the default &quot;Series 1&quot;. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#a4361fb66cf0e15501995f89466888578">chart_series_set_name</a>(series, <span class="stringliteral">&quot;=Sheet1!$B$1&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add the second series to the chart. */</span></div>
<div class="line">    series = <a class="code" href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a>(chart, <span class="stringliteral">&quot;=Sheet1!$A$2:$A$7&quot;</span>, <span class="stringliteral">&quot;=Sheet1!$C$2:$C$7&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set the name for the series instead of the default &quot;Series 2&quot;. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#a4361fb66cf0e15501995f89466888578">chart_series_set_name</a>(series, <span class="stringliteral">&quot;=Sheet1!$C$1&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Add a chart title and some axis labels. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#aa0a0b3eadc51a608c76bb9473943e191">chart_title_set_name</a>(chart,        <span class="stringliteral">&quot;Results of sample analysis&quot;</span>);</div>
<div class="line">    <a class="code" href="chart_8h.html#a650d569ff37a087101b7bff4ee7bb130">chart_axis_set_name</a>(chart-&gt;<a class="code" href="structlxw__chart.html#a17fa7931e6825a60de50444438e7f718">x_axis</a>, <span class="stringliteral">&quot;Test number&quot;</span>);</div>
<div class="line">    <a class="code" href="chart_8h.html#a650d569ff37a087101b7bff4ee7bb130">chart_axis_set_name</a>(chart-&gt;<a class="code" href="structlxw__chart.html#aec951bda729ea8184fa0827c5f091f37">y_axis</a>, <span class="stringliteral">&quot;Sample length (mm)&quot;</span>);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Set an Excel chart style. */</span></div>
<div class="line">    <a class="code" href="chart_8h.html#a6865755f0adb52e41466a6576a8a030e">chart_set_style</a>(chart, 13);</div>
<div class="line"> </div>
<div class="line">    <span class="comment">/* Insert the chart into the worksheet. */</span></div>
<div class="line">    <a class="code" href="worksheet_8h.html#ac2067faaacb8bfa6550b019e915900a2">worksheet_insert_chart</a>(worksheet, <a class="code" href="utility_8h.html#ad510ac6df573d23203374e24dba373d2">CELL</a>(<span class="stringliteral">&quot;E34&quot;</span>), chart);</div>
<div class="line"> </div>
<div class="line"> </div>
<div class="line">    <span class="keywordflow">return</span> <a name="a27"></a><a class="code" href="workbook_8h.html#ad9e7aeebc0fd43562db5bcd527b2ee5e">workbook_close</a>(workbook);</div>
<div class="line">}</div>
</div><!-- fragment --> </div><!-- contents -->
<div class="ttc" id="achart_8h_html_a6865755f0adb52e41466a6576a8a030e"><div class="ttname"><a href="chart_8h.html#a6865755f0adb52e41466a6576a8a030e">chart_set_style</a></div><div class="ttdeci">void chart_set_style(lxw_chart *chart, uint8_t style_id)</div><div class="ttdoc">Set the chart style type.</div></div>
<div class="ttc" id="aworkbook_8h_html_ad9e7aeebc0fd43562db5bcd527b2ee5e"><div class="ttname"><a href="workbook_8h.html#ad9e7aeebc0fd43562db5bcd527b2ee5e">workbook_close</a></div><div class="ttdeci">lxw_error workbook_close(lxw_workbook *workbook)</div><div class="ttdoc">Close the Workbook object and write the XLSX file.</div></div>
<div class="ttc" id="achart_8h_html_a9f577b0fcabe6cac9118a26a483fe85cab7d204b0c88aa41565b792a3ac946e73"><div class="ttname"><a href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85cab7d204b0c88aa41565b792a3ac946e73">LXW_CHART_AREA</a></div><div class="ttdeci">@ LXW_CHART_AREA</div><div class="ttdef"><b>Definition:</b> chart.h:95</div></div>
<div class="ttc" id="achart_8h_html_a4361fb66cf0e15501995f89466888578"><div class="ttname"><a href="chart_8h.html#a4361fb66cf0e15501995f89466888578">chart_series_set_name</a></div><div class="ttdeci">void chart_series_set_name(lxw_chart_series *series, const char *name)</div><div class="ttdoc">Set the name of a chart series range.</div></div>
<div class="ttc" id="achart_8h_html_a650d569ff37a087101b7bff4ee7bb130"><div class="ttname"><a href="chart_8h.html#a650d569ff37a087101b7bff4ee7bb130">chart_axis_set_name</a></div><div class="ttdeci">void chart_axis_set_name(lxw_chart_axis *axis, const char *name)</div><div class="ttdoc">Set the name caption of the an axis.</div></div>
<div class="ttc" id="achart_8h_html_ad60de0eb056e93435407e91482115f55"><div class="ttname"><a href="chart_8h.html#ad60de0eb056e93435407e91482115f55">chart_add_series</a></div><div class="ttdeci">lxw_chart_series * chart_add_series(lxw_chart *chart, const char *categories, const char *values)</div><div class="ttdoc">Add a data series to a chart.</div></div>
<div class="ttc" id="aworkbook_8h_html_a1cf96608a23ee4eb0e8467c15240d00b"><div class="ttname"><a href="workbook_8h.html#a1cf96608a23ee4eb0e8467c15240d00b">workbook_new</a></div><div class="ttdeci">lxw_workbook * workbook_new(const char *filename)</div><div class="ttdoc">Create a new workbook object.</div></div>
<div class="ttc" id="achart_8h_html_a9f577b0fcabe6cac9118a26a483fe85caf78202456c43feb53a91c2f56fd3341b"><div class="ttname"><a href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85caf78202456c43feb53a91c2f56fd3341b">LXW_CHART_AREA_STACKED</a></div><div class="ttdeci">@ LXW_CHART_AREA_STACKED</div><div class="ttdef"><b>Definition:</b> chart.h:98</div></div>
<div class="ttc" id="achart_8h_html_abfde30539e8538e64eee370797b4abc5"><div class="ttname"><a href="chart_8h.html#abfde30539e8538e64eee370797b4abc5">chart_series_set_categories</a></div><div class="ttdeci">void chart_series_set_categories(lxw_chart_series *series, const char *sheetname, lxw_row_t first_row, lxw_col_t first_col, lxw_row_t last_row, lxw_col_t last_col)</div><div class="ttdoc">Set a series &quot;categories&quot; range using row and column values.</div></div>
<div class="ttc" id="aformat_8h_html_a85e1b0baf44b445b65894e48722aec14"><div class="ttname"><a href="format_8h.html#a85e1b0baf44b445b65894e48722aec14">format_set_bold</a></div><div class="ttdeci">void format_set_bold(lxw_format *format)</div><div class="ttdoc">Turn on bold for the format font.</div></div>
<div class="ttc" id="astructlxw__worksheet_html"><div class="ttname"><a href="structlxw__worksheet.html">lxw_worksheet</a></div><div class="ttdoc">Struct to represent an Excel worksheet.</div><div class="ttdef"><b>Definition:</b> worksheet.h:1603</div></div>
<div class="ttc" id="astructlxw__format_html"><div class="ttname"><a href="structlxw__format.html">lxw_format</a></div><div class="ttdoc">Struct to represent the formatting properties of an Excel format.</div><div class="ttdef"><b>Definition:</b> format.h:358</div></div>
<div class="ttc" id="astructlxw__chart_html"><div class="ttname"><a href="structlxw__chart.html">lxw_chart</a></div><div class="ttdoc">Struct to represent an Excel chart.</div><div class="ttdef"><b>Definition:</b> chart.h:1086</div></div>
<div class="ttc" id="aworksheet_8h_html_ac2067faaacb8bfa6550b019e915900a2"><div class="ttname"><a href="worksheet_8h.html#ac2067faaacb8bfa6550b019e915900a2">worksheet_insert_chart</a></div><div class="ttdeci">lxw_error worksheet_insert_chart(lxw_worksheet *worksheet, lxw_row_t row, lxw_col_t col, lxw_chart *chart)</div><div class="ttdoc">Insert a chart object into a worksheet.</div></div>
<div class="ttc" id="astructlxw__chart__series_html"><div class="ttname"><a href="structlxw__chart__series.html">lxw_chart_series</a></div><div class="ttdoc">Struct to represent an Excel chart data series.</div><div class="ttdef"><b>Definition:</b> chart.h:957</div></div>
<div class="ttc" id="astructlxw__chart_html_aec951bda729ea8184fa0827c5f091f37"><div class="ttname"><a href="structlxw__chart.html#aec951bda729ea8184fa0827c5f091f37">lxw_chart::y_axis</a></div><div class="ttdeci">lxw_chart_axis * y_axis</div><div class="ttdef"><b>Definition:</b> chart.h:1107</div></div>
<div class="ttc" id="astructlxw__workbook_html"><div class="ttname"><a href="structlxw__workbook.html">lxw_workbook</a></div><div class="ttdoc">Struct to represent an Excel workbook.</div><div class="ttdef"><b>Definition:</b> workbook.h:273</div></div>
<div class="ttc" id="astructlxw__chart_html_a17fa7931e6825a60de50444438e7f718"><div class="ttname"><a href="structlxw__chart.html#a17fa7931e6825a60de50444438e7f718">lxw_chart::x_axis</a></div><div class="ttdeci">lxw_chart_axis * x_axis</div><div class="ttdef"><b>Definition:</b> chart.h:1101</div></div>
<div class="ttc" id="achart_8h_html_aa0a0b3eadc51a608c76bb9473943e191"><div class="ttname"><a href="chart_8h.html#aa0a0b3eadc51a608c76bb9473943e191">chart_title_set_name</a></div><div class="ttdeci">void chart_title_set_name(lxw_chart *chart, const char *name)</div><div class="ttdoc">Set the title of the chart.</div></div>
<div class="ttc" id="aworksheet_8h_html_ac208046e7a6d12cc87982422efa41b31"><div class="ttname"><a href="worksheet_8h.html#ac208046e7a6d12cc87982422efa41b31">worksheet_write_string</a></div><div class="ttdeci">lxw_error worksheet_write_string(lxw_worksheet *worksheet, lxw_row_t row, lxw_col_t col, const char *string, lxw_format *format)</div><div class="ttdoc">Write a string to a worksheet cell.</div></div>
<div class="ttc" id="aworksheet_8h_html_ad9fc47d3beaa2ab4759414e8580c2289"><div class="ttname"><a href="worksheet_8h.html#ad9fc47d3beaa2ab4759414e8580c2289">worksheet_write_number</a></div><div class="ttdeci">lxw_error worksheet_write_number(lxw_worksheet *worksheet, lxw_row_t row, lxw_col_t col, double number, lxw_format *format)</div><div class="ttdoc">Write a number to a worksheet cell.</div></div>
<div class="ttc" id="achart_8h_html_a9f577b0fcabe6cac9118a26a483fe85ca9df7f4ab4ee2fc2e45937e3937046d17"><div class="ttname"><a href="chart_8h.html#a9f577b0fcabe6cac9118a26a483fe85ca9df7f4ab4ee2fc2e45937e3937046d17">LXW_CHART_AREA_STACKED_PERCENT</a></div><div class="ttdeci">@ LXW_CHART_AREA_STACKED_PERCENT</div><div class="ttdef"><b>Definition:</b> chart.h:101</div></div>
<div class="ttc" id="autility_8h_html_ad510ac6df573d23203374e24dba373d2"><div class="ttname"><a href="utility_8h.html#ad510ac6df573d23203374e24dba373d2">CELL</a></div><div class="ttdeci">#define CELL(cell)</div><div class="ttdoc">Convert an Excel A1 cell string into a (row, col) pair.</div><div class="ttdef"><b>Definition:</b> utility.h:45</div></div>
<div class="ttc" id="aworkbook_8h_html_a81d456b4f65a464e78e4a0030ecc3c2e"><div class="ttname"><a href="workbook_8h.html#a81d456b4f65a464e78e4a0030ecc3c2e">workbook_add_worksheet</a></div><div class="ttdeci">lxw_worksheet * workbook_add_worksheet(lxw_workbook *workbook, const char *sheetname)</div><div class="ttdoc">Add a new worksheet to a workbook.</div></div>
<div class="ttc" id="achart_8h_html_ac29dbe36b53288990ec0b20dddbaf967"><div class="ttname"><a href="chart_8h.html#ac29dbe36b53288990ec0b20dddbaf967">chart_series_set_values</a></div><div class="ttdeci">void chart_series_set_values(lxw_chart_series *series, const char *sheetname, lxw_row_t first_row, lxw_col_t first_col, lxw_row_t last_row, lxw_col_t last_col)</div><div class="ttdoc">Set a series &quot;values&quot; range using row and column values.</div></div>
<div class="ttc" id="aworkbook_8h_html_a63b001ecefdbc4417986a3e344657726"><div class="ttname"><a href="workbook_8h.html#a63b001ecefdbc4417986a3e344657726">workbook_add_chart</a></div><div class="ttdeci">lxw_chart * workbook_add_chart(lxw_workbook *workbook, uint8_t chart_type)</div><div class="ttdoc">Create a new chart to be added to a worksheet:</div></div>
<div class="ttc" id="aworkbook_8h_html_a279a5d7075d09a3931aae9782afede33"><div class="ttname"><a href="workbook_8h.html#a279a5d7075d09a3931aae9782afede33">workbook_add_format</a></div><div class="ttdeci">lxw_format * workbook_add_format(lxw_workbook *workbook)</div><div class="ttdoc">Create a new Format object to formats cells in worksheets.</div></div>
<div class="ttc" id="achart_8h_html_afcd0c12a60048ef0240aba415f528e39"><div class="ttname"><a href="chart_8h.html#afcd0c12a60048ef0240aba415f528e39">chart_series_set_name_range</a></div><div class="ttdeci">void chart_series_set_name_range(lxw_chart_series *series, const char *sheetname, lxw_row_t row, lxw_col_t col)</div><div class="ttdoc">Set a series name formula using row and column values.</div></div>
<!-- HTML footer for doxygen 1.8.20-->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Copyright 2014-2020 John McNamara.
Generated by&#160;<a href="http://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.8.20
</small></address>
</body>
</html>
